from django.db import models


# Create your models here.

class DomainDate(models.Model):
    # 主键
    id = models.AutoField(primary_key=True)
    originalId = models.CharField(max_length=80)
    ipProtocol = models.CharField(max_length=80)
    rootId = models.CharField(max_length=50)
    totDataBytes = models.CharField(max_length=50)
    srcDataBytes = models.CharField(max_length=80)
    dstDataBytes = models.CharField(max_length=80)
    firstPacket = models.CharField(max_length=80)
    lastPacket = models.CharField(max_length=80)
    srcIp = models.CharField(max_length=80)
    srcPort = models.CharField(max_length=80)
    dstIp = models.CharField(max_length=80)
    dstPort = models.CharField(max_length=80)
    totPackets = models.CharField(max_length=80)
    srcPackets = models.CharField(max_length=80)
    # tradProfit = models.DecimalField('tradProfit', decimal_places=2, max_digits=8)
    dstPackets = models.CharField(max_length=80)
    totBytes = models.CharField(max_length=80)
    srcBytes = models.CharField(max_length=80)
    dstBytes = models.CharField(max_length=80)
    node = models.CharField(max_length=80)
    uri = models.CharField(max_length=2000)
    srcGEO = models.CharField(max_length=80)
    # tradProfit = models.DecimalField('tradProfit', decimal_places=2, max_digits=8)
    dstGEO = models.CharField(max_length=80)
    subject = models.CharField(max_length=80)
    src = models.CharField(max_length=80)
    dst = models.CharField(max_length=80)
    filename = models.CharField(max_length=80)
    host = models.CharField(max_length=500)
    certificate = models.CharField(max_length=80)
    # tradProfit = models.DecimalField('tradProfit', decimal_places=2, max_digits=8)
    channel = models.CharField(max_length=80)
    url = models.CharField(max_length=800)


class DomainUrl(models.Model):
    # 主键
    id = models.AutoField(primary_key=True)
    url = models.CharField(max_length=500)

